package org.jeecg.modules.yusuannz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.system.entity.SysDepart;
import org.jeecg.modules.yusuan.entity.CaiwuShangnian;
import org.jeecg.modules.yusuannz.entity.CaiwuXiangmuNz;

import java.util.List;
import java.util.Map;

/**
 * @Description: caiwu_yusuan
 * @Author: jeecg-boot
 * @Date:   2020-06-15
 * @Version: V1.0
 */
public interface CaiwuXiangmuNzMapper extends BaseMapper<CaiwuXiangmuNz> {

    List<CaiwuXiangmuNz> listData(@Param("deptId") String deptId, @Param("categoryPid") String categoryPid);

    @Select("select shenheshu,category_id as categoryId from caiwu_xiangmu_nz where dept_id = #{deptId}")
    List<Map> shenheshu(@Param("deptId") String deptId);

    List<Map> duixiaShenheshu(@Param("deptList") List<SysDepart> deptList);
}
